SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521396 LIMIT 1 [ RunTime:0.001046s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521396 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485665,903103,944473,833973,511654,36130,980371,360669,443878,1008990,226934,739180,546111,1016478,9893,151252,506047,169540,862877,376001,207590,173658,1005596,669809,890313,72216,503906,833580,703178,279315,480882,598345,56972,365073,346185,82490,886756,156676,141971,945627,856690,104539,150894,785333,210396,527991,672141,615977,511542,167210,274823,514762,561684,55444,169236,971798,112869,185089,111324,155940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]