SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286691 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286691 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128130,710633,1022565,1009948,812937,564403,417414,725430,437472,1016861,5163,1017231,723115,359537,352569,631442,1042012,1031640,1027991,1045341,352028,958718,758301,539681,678800,467865,486440,842803,905553,507939,837642,740041,306620,109379,358723,591466,910164,295171,637008,759402,826782,976018,967504,66764,413879,228960,372977,646087,197126,162725,1032895,1035783,209800,440793,208790,202025,295540,565504,36946,320768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]