SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454856 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454856 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503479,986711,384188,501841,391118,606225,198497,913939,488774,70273,1018174,436377,638450,63625,975872,688928,450846,692744,715063,356650,175390,235710,79304,617352,582106,1047656,651369,251103,877038,213740,971982,142864,803391,728611,977438,385426,8189,555232,394394,535467,772723,526806,171241,389022,1019437,333007,850099,312051,453379,714138,392705,960558,495943,703339,171670,102450,712772,377191,214647,42167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]