SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181872 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181872 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278230,23148,776037,1039522,298332,694396,444556,262352,174213,275726,688340,37876,284795,581071,481594,150310,999216,802242,587716,778943,558896,53637,737122,102090,158210,775608,260067,206823,914572,871232,350665,924731,589536,345784,543896,451552,485030,658566,250306,400438,202920,986221,1043399,282220,71972,651614,638216,428695,991543,89880,712306,129072,706887,486709,94537,462629,104096,388232,797627,594325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]