SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479717 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479717 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037925,935965,1022542,159119,1006906,458941,208672,969133,484890,401577,902086,483223,436473,493240,896364,604470,108449,313422,747647,49366,1041488,832756,955978,1016488,240755,1001172,1025118,243887,1024048,1045335,1033818,598299,119899,317751,58380,492573,791474,495601,149168,438727,315751,910161,958951,1008628,1019638,568485,503598,621686,1023531,665676,747452,967141,869704,575118,373848,874076,323841,1017648,640255,862486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]