SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614840 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614840 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383247,297346,188103,668142,54594,615616,749159,175880,348588,729011,184860,68703,124339,511339,766108,724890,42026,258027,111178,990817,359537,305479,477567,510798,579534,613955,903073,732903,830818,249506,842834,525826,823581,348700,934932,912555,750168,194592,967066,545340,277778,884580,366675,87143,147732,997079,792206,19948,496861,360517,430260,934938,298276,614746,989338,472485,956756,768551,537432,405415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]