SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540541 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540541 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284017,683228,486815,814102,193826,44489,698227,442502,2288,445370,997613,68791,897205,176605,260037,1023388,407083,509409,347846,149129,966009,335284,353600,966605,560250,337951,901434,1025805,224468,399938,598293,765927,455494,801147,956761,50632,944198,992221,375923,1005807,1017628,159361,363403,230071,875237,548189,788660,276255,894175,960810,299573,856235,494924,240019,848300,457087,738495,887086,856375,964710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]