SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397583 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397583 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798516,596245,1030181,242085,270395,537228,113658,282631,37724,947544,627043,8248,545998,1031361,679115,840716,16074,647179,300541,220962,152020,149597,386946,192396,148237,231243,28959,513416,721372,260322,337396,617016,981203,617215,69299,759299,457710,676182,279529,653060,548065,45450,817327,213905,450558,497589,434034,574667,528744,23974,578481,220701,1046371,599665,921193,483331,1010486,374851,986402,110746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]