SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101141 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101141 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142514,885042,194252,168774,662674,827058,949315,482868,700614,389167,526891,138803,892459,53,703453,296708,103464,630687,968400,531127,484746,475478,704300,126570,182793,570407,231252,414711,661296,736340,924696,346866,2553,112605,229814,517935,827109,394609,582873,847110,604902,236261,517401,1044831,758156,90099,519766,1046167,366724,202682,481003,481575,391351,945118,195501,635856,553877,788780,198388,878140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]