SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396405 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396405 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021145,303172,434095,602894,334980,263987,664188,771048,330848,32163,1036188,728232,770295,1044647,367526,467295,585035,192689,766416,901819,47388,1008358,1025244,190449,228648,270439,429510,1041538,832625,558794,563784,258111,194566,316363,715110,306458,159537,816072,761597,974707,371084,332708,113439,973319,619584,109453,148985,800676,164691,85075,107531,942853,620863,145305,126952,257206,674872,313406,120891,423235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]