SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017172 LIMIT 1 [ RunTime:0.002116s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017172 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523690,319116,60924,1000215,197614,266913,915673,567664,292646,959514,887075,1006097,445809,342057,61075,681022,858670,948558,38928,687899,983752,571537,179921,114451,585933,70766,114114,234613,955720,712198,273334,788941,350706,382856,933287,739471,255128,610617,705503,985606,837698,85100,710488,135317,766573,305479,211523,719181,987299,834239,763358,594167,332064,256463,857609,468417,796164,631426,916201,44067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]