SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391506 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391506 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289669,1032216,668366,337720,861012,742072,414812,20030,231259,675690,518212,304942,194612,329658,332528,92750,44430,38082,669293,1019489,487883,315860,535875,94964,1034749,1014367,648156,766377,64128,487425,336066,339914,1030174,438999,203617,750525,329261,99014,450291,943816,214055,295667,700783,774403,249501,130866,1048457,695386,210277,469609,717232,246123,1036330,392992,113469,200209,298557,35949,395384,950912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]