SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509853 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509853 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923612,941146,884170,521111,520880,1036401,906847,143933,882984,360125,258135,746571,504672,870358,815491,918831,874888,438963,173233,36076,1041476,619371,173155,256086,455432,123632,693677,834374,667964,446888,409939,592750,553753,878204,8396,411316,757774,174342,625428,50044,943385,759737,666406,458880,369658,369468,873590,531642,645662,70671,734716,643301,514654,329110,968192,540905,197121,895582,1000552,1007626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]