SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402718 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402718 [ RunTime:0.003076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14684,520062,595184,535161,269374,674164,198193,753176,279338,290612,112009,301541,288219,634999,656186,196669,571665,1006288,481661,78557,724029,947128,57516,587469,891015,377046,91541,986654,378236,918047,1026439,710385,394312,641991,519674,432666,35165,1004861,748456,837358,415812,676722,123047,103856,709856,11730,904485,519833,891913,696907,536970,299071,984842,149162,77213,57760,93386,913042,607552,136751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]