SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43808 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43808 [ RunTime:0.005178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769612,728375,118948,765973,206600,996451,609125,784361,519062,839811,945333,384030,867744,277174,297719,498788,415938,752981,715619,347843,1014874,397399,249228,616502,841879,855683,318482,741634,1007978,804630,968655,452685,481281,342516,604378,642083,242253,341180,1029579,616411,64520,351847,639027,20904,594357,708205,11713,321731,55206,641169,971225,84687,11609,473677,364493,146754,743389,681873,944873,111632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]