SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497533 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497533 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643555,234047,990971,911448,268481,95408,964310,82826,221737,490090,322223,350858,398211,337603,244476,412111,76214,279193,156496,38397,83586,303832,281499,562063,161565,226926,655679,409057,486565,246960,1023549,504589,460895,65087,692813,344989,825383,1034130,97231,318321,763747,474933,153445,28559,347930,155908,570117,894512,937375,554148,694333,112424,190994,294490,737257,269471,300447,1030383,447700,369916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]