SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003993 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003993 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550348,375666,146124,132994,434616,974425,683335,134686,823213,995491,1001655,301227,404898,987120,640207,531480,1030324,427098,636176,370212,904099,128691,106645,788549,517821,687518,879738,906499,166599,215495,415339,397335,957706,1033079,654948,535609,787552,996569,30038,527740,620886,1044422,134108,680303,496202,718869,692372,552072,55399,21888,1038786,834245,761351,375020,950926,56985,558239,436348,941904,290406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001075s ]