SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119403 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119403 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112940,670575,974696,905989,414293,802104,845873,671760,1027650,580814,274385,285858,687859,108645,863380,483537,767486,356259,616858,598789,920972,978190,365298,284710,448030,50440,245105,621432,407289,401335,244050,953036,893313,256057,135950,231530,193941,323524,670221,376659,666709,756780,132296,96600,976420,71770,162767,809610,96510,944322,861803,689234,685170,640424,922594,236036,52676,796513,542735,374691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]