SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454500 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454500 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568539,171735,729726,686082,636104,116718,859207,833647,1030211,789625,57234,182039,922204,755643,389425,113937,352991,377962,1011920,226181,142244,457793,36152,428669,789159,361301,595932,60488,486805,631787,346670,430056,279346,595949,50113,761803,261029,737714,197681,45233,562283,998248,153663,442726,253722,48152,176136,558135,265691,636184,550783,93003,459906,339718,27989,947069,930446,614181,990955,100463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]