SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466728 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466728 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482705,203083,520279,661831,511978,287089,762623,964809,837065,724365,717026,738305,500821,211211,448521,12564,199159,364767,94137,881938,922120,951193,278627,628229,49362,107835,603965,306811,914514,171267,653468,695876,319094,717725,377853,1041244,129923,379437,784592,966880,90584,214830,534534,459631,699510,197368,217983,1021393,994185,650740,1028372,336214,899705,776361,577600,598785,874454,523536,372574,924956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001040s ]