SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326108 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326108 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420143,491803,841804,509949,501603,543500,966686,25189,274405,288186,293518,661660,993127,176892,234883,840453,205439,484631,742488,609818,524693,239694,842495,227438,201589,131787,31353,415475,646892,12870,736181,228834,103441,1048347,156031,488935,601377,550804,31106,965185,929041,619299,42856,303791,652604,551316,824233,769080,624994,636266,545895,598115,237784,503296,132089,722875,1043553,195253,9702,1015523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]