SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545053 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545053 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442887,728616,280286,530305,270497,199509,71916,303719,854826,583338,141787,666020,425929,995827,471088,947294,168874,266939,350216,76501,285622,620148,287887,874287,853966,1038666,976328,689281,469746,414519,608257,658687,641153,91469,76742,826562,615909,727033,261063,212219,104476,141213,967555,373496,303190,283863,637169,632655,1004753,477033,33456,441038,331748,348903,121256,791583,266976,141470,744169,264956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]