SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115541 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115541 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20088,939249,500493,980832,424540,239429,692429,765047,931951,293894,457402,71806,156445,665183,605589,300592,67568,204197,913953,626415,607021,111985,60189,738798,402608,672741,677986,235988,966883,126419,128736,277858,969996,453742,1031713,211474,960786,677642,845098,919871,215096,4545,5387,745744,302388,356404,401572,966176,682760,42181,916601,59959,140985,376412,945203,175763,861389,959106,365089,518728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]