SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505327 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505327 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368075,819722,1004162,474179,665113,66727,387301,19417,1008617,364892,723653,1036836,1002808,494421,45003,135201,439318,4379,826553,120848,848718,1026936,441728,967709,952719,596723,675680,527837,824830,770968,168552,27695,543640,981297,906810,533438,235342,434067,793628,501863,224075,108459,52199,140033,361133,36783,764722,801019,723844,203010,897589,920687,112651,367516,577361,642732,194095,685495,804365,662876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]