SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534078 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534078 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153982,420697,418937,4117,828168,512256,2340,736388,1008480,420167,929225,737372,345790,1030474,893262,794557,548235,599992,130649,193139,974971,482461,948827,621119,73295,103331,737497,78320,580499,106813,798805,217525,386693,749770,1014734,618010,43528,440124,293878,218851,344293,780335,451716,944740,405797,124311,39380,277011,956586,120410,564589,941833,319185,986499,741583,480492,888374,214215,918695,113980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]