SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528805 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528805 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356996,232731,945260,680773,520145,970413,741510,81661,242034,114569,518259,999645,757096,611459,290522,451186,536786,141126,45900,395350,341816,509302,976119,114957,928282,213103,376699,78073,713181,960941,807414,599164,405834,665509,38459,265954,717080,69799,741735,392790,1012202,175192,445588,669998,355043,219263,17868,205782,1044961,1026586,67076,6128,607415,415075,626667,460558,1007403,430626,550864,85885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]