SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526580 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526580 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017428,368317,842807,75926,50445,585026,456582,625878,510187,553439,432489,306190,717174,799879,530625,795459,256543,326584,216484,759513,457466,415554,704418,282912,885553,965703,220448,101221,645428,283046,103585,435328,362641,794557,730019,978574,429558,1045268,662229,47685,172389,66875,566314,145233,861164,580754,32959,301684,777709,557383,636958,313701,494108,227631,947481,999264,673499,771615,712068,652917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]