SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488298 LIMIT 1 [ RunTime:0.002981s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488298 [ RunTime:0.004054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43017,571248,226121,995477,327268,664030,590422,250769,707521,767177,848040,82473,559348,664914,151892,499688,298347,1048907,985552,380932,163726,193580,220201,899469,638097,535884,963021,157328,980865,691040,601749,860947,482099,526396,256647,700067,706946,889496,584120,351286,401714,591241,1043285,58994,920904,299764,167809,199184,1008633,781953,120150,796595,320441,972670,775940,232011,1021461,236282,593462,340248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]