SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579943 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579943 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65545,703112,227010,351103,1045127,763968,111757,315860,809795,604602,681778,691588,227625,400444,138483,945884,309645,702725,829990,643829,871648,407802,649638,654250,130922,430855,301036,692237,452711,514796,927090,849043,163605,951920,115412,149076,366969,75540,517307,495751,956660,720296,249977,451923,426234,570566,86022,432219,371301,748754,701332,658904,577605,861335,685263,339646,458255,42024,558196,90908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]