SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002795s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316576 LIMIT 1 [ RunTime:0.005019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316576 [ RunTime:0.004402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123630,63610,828398,994430,312242,965467,170802,724351,721938,691912,178370,1013232,579295,1043014,775583,654683,616401,1027056,695841,301540,348785,553806,537408,597546,1041963,560785,577685,345847,989148,640368,372996,418865,1036965,855238,945584,235746,628255,146365,780334,535149,149544,275650,414309,638851,25481,788831,699863,648044,90762,743415,844764,772764,548753,181022,510345,264440,977864,152268,211216,839528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]