SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184122 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184122 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022455,694139,400028,710202,970906,378181,516982,802601,948350,567380,986321,914054,75187,719262,33203,783447,374977,945940,368736,474660,178736,75794,800743,753604,26966,867379,653684,59810,216953,169720,825900,529678,943884,611631,470380,700714,243062,665955,173933,395404,628700,570479,975474,266856,960333,971660,616870,208788,945282,320148,31571,355379,435465,35709,463108,232018,940053,488442,337194,582314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]