SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149689 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149689 [ RunTime:0.004565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435691,792512,235988,277669,599725,994402,937042,787354,728921,262785,645906,964320,116203,115916,465726,123514,1038250,76633,63423,865538,41922,173336,659193,646208,453269,777156,338735,845850,500283,488786,153571,925591,930561,487629,45519,567289,357682,178148,72055,119774,468326,159488,663868,77031,1001450,151906,69371,46845,600563,967823,551999,997928,952016,572869,392171,55161,155472,184597,1046199,67578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]