SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509190 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509190 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003421,400243,41934,746967,192283,508885,529597,881463,335170,687792,856924,848069,653151,304398,919497,816946,889286,270741,872843,205669,465674,354238,426759,187361,963098,162583,675779,402824,622683,996883,86394,814730,244879,369696,389079,21282,587552,157633,548726,163611,383323,890777,716739,164323,159751,40774,13315,838514,885771,540821,594461,549292,200479,26111,358754,177330,51634,256741,327303,1542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]