SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407825 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407825 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315403,798442,583491,167295,367320,466911,935574,424236,194594,191270,1011952,500284,296313,660981,915028,484393,736331,321646,320341,789832,846938,942326,820860,224789,447671,289146,81492,156168,366161,898522,684971,217364,730414,982844,260981,785403,691254,762002,937146,797148,539167,369129,589322,641683,909331,202763,520941,87915,531825,743676,890681,818897,712513,53664,360538,276010,329599,316036,355871,28085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]