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` = 193922 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193922 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112780,118700,116087,289240,130590,895968,40520,36741,252899,118475,269892,61122,984959,373788,497719,190391,448503,671820,41638,185035,192573,430891,223012,1034368,1029766,175976,524211,415601,1019450,211126,684988,193294,166119,1007217,1012595,424129,766579,223345,1018561,28186,280726,497566,567081,466911,186552,925143,906953,726532,139400,24219,678557,882444,389290,49099,907408,914615,76106,596595,777159,862301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]