SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429071 LIMIT 1 [ RunTime:0.003618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429071 [ RunTime:0.007707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907741,153419,910303,689274,117671,184877,185150,294957,153100,303349,606457,418403,7095,14085,993633,1040118,72727,983603,692659,601534,847029,756100,669565,28727,862269,546744,166841,201165,755297,18531,640372,950866,133640,354204,189408,360751,754118,788395,202608,53777,867651,649478,512415,686503,736461,864500,926351,501849,521276,378115,787668,12001,885284,736258,799499,381525,915532,379404,889402,542010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006168s ]