SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269180 LIMIT 1 [ RunTime:0.001055s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269180 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602900,949914,160874,233566,710917,814518,850747,449687,734594,549152,352022,769138,649879,628353,503956,1009182,762722,298953,9125,460931,676798,989167,505679,728490,588797,429016,73183,33841,1019986,730599,980545,132137,1036849,502202,761176,62383,812424,604443,531600,589896,573571,902281,764531,895013,73894,179099,403691,763262,399706,670038,4387,312032,1009176,263313,686526,927913,726602,910879,278444,164234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]