SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019930 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019930 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300716,833835,497432,778971,308323,323128,1036030,12180,382649,301001,141148,970701,758002,785992,398540,402268,289290,423338,314250,737294,64092,257774,310709,785917,1024434,835558,828748,945878,914100,443579,988445,371646,790316,504324,376766,838482,754289,248540,657304,824520,592259,386144,293979,803408,353173,191780,477967,970535,468783,253312,579922,405119,393123,993762,150770,660145,89452,684616,588468,467639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]