SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102223 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102223 [ RunTime:0.003249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68459,863494,242188,586373,271121,481040,174732,714590,757524,418629,951111,553890,474230,1045782,837249,783556,814405,635863,89882,511663,80852,1012280,402408,99988,868729,950722,767194,710220,375538,558990,76653,359619,540594,175358,737915,179975,928117,407540,73910,35104,789313,171032,380295,830105,265141,451085,597299,718260,46448,459821,409799,6734,406818,621165,410148,130481,603211,981767,122958,716919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]