SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027203 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027203 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184567,722980,927725,665475,444581,836797,608094,837702,385724,7245,195321,528003,1021143,474420,721220,676830,276093,475715,693094,309629,465233,842328,859663,309987,112551,499590,16489,112321,839300,870551,1045256,596856,324252,931407,364059,599680,988772,894329,91816,27381,574587,792206,467095,433240,127439,473615,991383,721132,470494,920113,211190,377953,904119,735016,116744,482701,384223,955534,218336,756180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]