SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014307 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014307 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532314,862786,263278,1022142,799618,813648,696326,185523,728212,299886,1035329,561075,162993,539700,647135,920577,148036,732435,339180,708633,323690,97927,857015,891751,249624,239425,34535,693828,368155,188414,676943,542831,591543,38585,170677,655961,691833,26048,1039551,33964,268900,786343,802178,189194,324362,665461,300156,194401,563798,262985,312678,224250,797658,945921,800152,948693,788989,1016594,384532,811174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]