SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260584 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260584 [ RunTime:0.005794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239237,165739,260624,175631,876823,580795,174019,266509,257197,175890,80539,217418,649383,231772,633490,143138,449289,1010054,775796,142840,127659,671440,304517,794034,1030432,142264,1041879,757930,940698,659731,248347,203523,752410,200779,804630,800910,960825,771389,866482,868571,502182,799919,307881,182952,348611,707949,466033,981260,480467,303308,279525,79257,112198,991509,821256,1000255,815957,1045656,487938,812777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]