SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804580 LIMIT 1 [ RunTime:0.001639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804580 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711738,199447,388938,1026566,385255,76690,824487,416070,141579,87909,489111,986933,540084,1009628,64858,926946,600937,723758,482391,742351,270865,152804,270666,661966,770412,321345,745055,234565,236053,792477,2139,105740,579342,844566,524543,982918,1007500,2307,498716,675749,731401,585982,1016759,903493,1006155,1039961,8343,834832,428849,113481,843815,246097,765238,968693,244783,527017,740847,54227,660261,14921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]