SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508844 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508844 [ RunTime:0.004099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231509,593851,324785,294394,975386,702205,659375,1010446,123942,150,595149,293143,949199,128660,193768,275712,1043621,710714,509614,583692,1041894,216298,926122,30907,264952,1004560,397523,560272,6638,974856,1013506,627160,462507,354209,938125,437744,117578,504772,407427,324231,531974,603785,245557,682031,297335,753725,563568,109426,938646,47684,549992,755783,175962,774787,804166,1021445,708548,1029540,146601,959822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]