SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019954 LIMIT 1 [ RunTime:0.001427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019954 [ RunTime:0.005190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228833,712902,195808,884015,520375,815363,386353,407942,234398,899074,409907,108255,303338,510559,703585,223168,222479,539742,971881,771772,657167,1011193,667389,173646,30795,634001,160282,660462,77238,505452,386127,452564,2473,60824,708522,288263,191116,588466,137775,386082,985927,954448,913830,932260,851457,261650,561618,587550,735206,2286,498184,287248,529207,959600,326566,1002986,80919,565221,980983,548796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]