SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978081 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978081 [ RunTime:0.003168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457054,468671,746538,396908,705347,101856,1029276,590449,950516,560661,589708,482194,119533,392906,520120,575690,699478,374444,1020430,612208,181579,899498,795690,127929,75968,77239,365914,462370,1006409,489206,523369,563534,53027,77495,574680,396401,718114,290698,1041757,690009,908112,655579,283414,437733,205539,128882,344369,902978,31665,699418,68977,37985,488683,684924,875487,638379,598948,255793,386606,438033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]