SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504723 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504723 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993005,9304,339922,604631,589045,682588,364631,637541,831979,966530,412756,236257,764701,503894,947938,158651,1030194,841511,48546,972264,93837,842883,641873,957609,371933,997572,194555,373650,199825,589962,291632,784906,89083,755591,1031939,305471,921379,409988,56436,829801,637225,256342,780915,634058,162729,948417,941690,676140,951053,196796,839121,99895,340372,466194,49376,898180,36135,742000,4734,343120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]