SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402806 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402806 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71805,782258,778455,963855,39735,157936,777632,619117,748699,300598,733537,194647,177539,488602,961613,163643,234763,364337,791873,817470,894680,802096,813100,118338,159217,718314,393950,905665,492238,284679,321958,171466,818859,38368,841960,615995,940847,860198,683819,342588,287532,6694,415152,207452,113668,405469,669060,54873,377686,419313,584082,982657,187794,839330,454772,144413,835367,416728,771081,1025108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]