SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427798 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427798 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154960,252840,437368,1031001,1024590,730087,713142,494206,683592,580365,151188,366020,596230,419698,981707,1018670,966371,606016,234895,185305,503640,168004,416042,224523,959980,122203,687185,528917,1045761,936061,48216,426050,548245,44193,887457,330476,1005783,572690,746435,451545,175824,759694,573063,740128,784762,577423,584098,1040165,135471,269421,842200,176041,537767,344257,415964,870564,717543,174846,292296,336931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]