SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50765 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50765 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889544,670573,72296,1033926,407360,765726,590138,852274,695026,775912,913863,731551,759037,372358,42897,21398,15755,553266,696630,951586,314834,1009151,274366,499747,516078,961416,211542,43101,333656,785757,924355,764481,237934,148708,130496,481175,877227,728822,461454,968419,861078,181276,483665,109152,500587,74075,857545,290890,861330,527724,791,99254,394563,63861,943185,626007,419182,111002,430425,977269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]