SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567954 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567954 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537042,390475,391136,555288,765710,940064,247187,269035,220503,409185,549016,617161,40190,212680,1003253,814397,267798,849197,470170,630878,258335,219273,472629,526009,752594,441593,583289,328449,358213,1018955,64379,701805,879734,239503,3179,601952,899440,722580,627716,823576,843076,646619,347974,52455,698368,397766,612147,822161,358934,855023,130670,870668,519929,278678,416132,730278,850556,272568,523462,246515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]