SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498191 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498191 [ RunTime:0.005476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639832,368459,404363,322180,306193,614566,688304,997386,121578,141927,899618,1021291,908231,380325,1018601,916558,813148,343114,826891,71192,165396,775965,716018,25458,224713,886693,393901,448546,909249,1019669,657682,179754,716434,294830,324907,718657,348836,245560,208517,272793,893516,83439,347538,737137,486564,369351,1041636,695335,778024,736080,441300,955161,1003167,649154,380133,1001343,1025145,517964,569429,371266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]