SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470904 LIMIT 1 [ RunTime:0.002829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470904 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782318,441690,205075,999275,550113,900192,676938,930575,588047,750512,478867,197001,810390,1027228,559662,127943,818663,678149,266501,276799,886940,955643,1029356,399858,747091,24418,273059,313049,336577,861305,485558,1012749,703641,274614,300813,924272,956812,198234,8875,471385,956159,1017282,162593,699197,1042359,531526,141651,333976,834594,416087,827794,438202,750021,450430,28204,568767,600940,555826,140205,892072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]