SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025828 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025828 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595977,313422,357854,49880,310586,505002,320132,923901,414779,772764,295215,1025939,513249,229844,311804,746910,425350,439567,804649,152202,370625,963808,534055,352392,536680,265000,488420,155942,732820,27221,902429,910263,375484,996076,570697,787180,142566,176896,493989,412235,577743,813802,415145,728107,81655,386761,12496,1001581,331677,643638,434932,428879,999857,231369,572837,121267,469669,626217,345396,278299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]