SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038781 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038781 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311656,609630,193981,102922,343945,236914,302578,595281,716166,464210,482631,846708,739654,85215,770857,63154,86813,551706,959068,941152,641788,218888,1026698,527184,149768,75003,760567,338619,692630,294031,567685,419756,524959,511802,753197,865077,716974,509857,224437,739483,374488,184719,867137,953127,788538,703628,475504,121398,424653,800662,298327,159643,805628,290588,763135,342829,37920,706770,417010,566986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]