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` = 488142 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488142 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433106,162409,529157,327475,386779,153065,148515,383950,273434,926279,174085,322823,709017,467592,147823,187317,39712,111460,756571,337014,220816,159939,945955,126837,32934,476090,957679,255425,174029,429777,989417,43988,219106,751395,94714,501813,881404,890722,793148,152489,150955,471141,622952,1042285,998240,943788,88142,68729,904021,286578,397048,198681,892570,397912,107252,373488,520681,789731,259327,453587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]