SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475036 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475036 [ RunTime:0.001444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194635,562078,897130,464435,447367,428609,342818,664121,2323,256377,572928,363031,24678,339419,665128,389118,508609,590188,783759,128790,547301,627588,943412,415937,752465,1035647,460225,826795,61636,805814,289250,304467,813651,136748,784453,918434,873596,575593,201081,904496,859205,806813,61297,138975,616179,801130,698906,608335,875550,590504,128990,927766,616202,61770,115076,832196,257723,124741,715998,28263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]