SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504262 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504262 [ RunTime:0.001372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292411,584283,901756,679853,128562,814621,146672,31705,607319,1043929,615669,242628,145737,751484,847180,164291,989716,547809,691979,256596,304584,64114,926022,334256,627781,190448,570819,930856,581484,168730,905139,650581,197674,212125,925734,960065,539358,1026614,940725,123025,280314,898130,462053,157410,317172,192377,385898,1017364,608601,813671,58177,810132,758962,155157,501368,550905,1005620,536464,329392,453523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]