SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423366 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423366 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040846,266951,223034,280987,379300,629005,320804,993944,340253,338033,665930,77338,620177,702385,761908,829903,987817,195342,194587,537355,428874,674038,1040060,892911,924122,356615,655168,1030326,953855,110314,595706,364938,935924,370356,432218,430951,338252,160205,584325,750532,139850,22211,641743,413031,779202,688560,173048,644243,237569,201696,771897,741248,687593,339677,1045712,953405,509580,341521,605854,1033381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]