SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008070 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008070 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266577,427401,728223,299166,964103,834761,1037856,656769,28324,376190,666756,221825,286593,547226,323122,531055,294084,500565,144083,141968,637281,424243,544049,537332,400145,527374,616917,154319,568983,260573,216277,414323,1036166,398892,722268,231631,628352,495754,1002220,125093,853355,435885,658543,370280,824962,305976,397751,962518,102913,365849,903547,80224,389787,502759,1003232,374535,607641,393952,984862,824434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000356s ]