SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314293 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314293 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759475,925777,261100,559110,450845,161859,821870,47383,690131,894495,626716,492671,210611,667682,133162,397256,459514,548394,671089,451732,391662,43968,1011330,390583,876235,590265,444899,312167,746566,486972,578800,82758,459634,213979,535571,647631,359334,977050,492968,799901,314967,343000,798482,175940,1889,373447,548706,715949,668829,534397,983679,413936,32808,118283,111875,377163,666909,997750,539720,488365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]