SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563818 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563818 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929200,125600,327557,703768,764808,922949,293576,249260,90216,642696,483147,689438,1048680,1029684,907401,776694,626520,355952,1001977,474123,350489,325229,382358,608505,478912,987221,7003,636872,940192,524002,839274,603679,505428,553087,255812,882569,311465,510793,799002,769136,669560,516553,867764,78812,1681,1028759,310734,876893,147921,997601,664695,747087,66651,779682,915224,618312,878298,671473,488748,260657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000866s ]