SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427962 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427962 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395821,484578,944649,944374,368524,87365,266474,297355,445245,155295,715503,135245,558309,745695,46908,307048,394139,833890,291253,385394,979838,508863,641551,349352,841439,1020654,969262,323894,309092,644711,970861,1042228,1029747,755129,310114,188956,1018037,456982,598094,80727,293466,821111,598148,668282,54236,842687,405220,178889,342279,338062,636076,321828,823345,212817,705383,686240,296973,532798,262681,829445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]