SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251509 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251509 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656916,57215,117910,494669,303232,737556,210890,277719,587505,466060,395881,763714,138386,992448,1034820,921538,973313,333246,386864,730612,101145,534109,196448,841095,421324,953720,620927,539053,10841,972850,225598,452229,648666,84868,211535,102404,241436,855479,518839,711069,747605,951126,1004299,371418,798519,491505,580148,869476,853852,973302,276859,900518,113792,798808,695484,830515,316778,671455,208926,566832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]