SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523540 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523540 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746787,546479,832514,554814,575108,357161,547098,719382,529489,407860,953902,684743,840248,812209,45517,473402,163362,165903,843142,537957,795821,389685,304753,837952,343944,378832,54033,900667,898985,891034,496804,675689,145028,597396,414741,550051,303698,701733,18002,1012560,282465,390686,62957,30885,162519,588420,534909,537451,948718,132505,1045992,859500,643925,589007,32431,389182,980975,664965,262780,788183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001467s ]