SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405861 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405861 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947028,771075,47841,741684,19419,455509,55017,533012,402205,131634,756793,439329,112328,802212,735102,438412,862025,975544,111988,913496,493300,408885,507911,903378,380532,31504,635770,186408,16539,626816,376307,10057,717178,963799,594686,258525,6451,768253,883663,942508,518154,274299,40878,474102,171143,459898,622092,518870,958527,329292,363362,428625,715425,715602,753479,61117,98601,911882,969338,1022473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]