SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261180 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261180 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692583,250490,505708,848314,927828,457525,1014508,981962,729769,57570,738023,195446,1029296,788121,328286,989898,926880,398539,125701,431657,15692,1009070,953059,803192,191221,876027,748904,678049,40496,160421,118815,706348,311385,670182,979204,317969,424569,142972,76272,661565,77387,328855,640164,553914,1682,878112,861040,814479,370061,163720,872023,755258,122840,572449,381272,258476,443522,1016048,129246,78816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]