SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981610 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981610 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798678,339337,827949,627147,382061,827793,753923,444311,607449,228120,808776,245709,445981,250188,910084,139679,745579,160521,562066,555689,701126,653470,569809,518345,707436,544009,51295,521161,890228,567312,673691,570864,342703,464628,558747,405917,779791,238510,97070,281842,226023,542730,24018,654798,85651,396528,717811,271993,446946,377953,657783,664506,93347,111799,557079,553866,105819,272346,73945,90334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]