SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910909 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910909 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427988,183962,738641,312289,791345,804695,611171,480338,603612,479629,617517,386505,880031,818847,785318,637933,95740,900096,199968,594030,295194,58453,911926,979566,311097,634359,1019815,619494,907535,640432,189824,691352,899035,57233,1021392,143460,44140,577737,948378,812044,228221,852635,361439,772797,871375,181796,896787,599649,255167,821567,901515,667450,611399,988825,195320,937782,883443,147458,494577,886621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]