SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509001 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509001 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809897,387486,397236,919465,33198,648357,491841,44094,564453,312773,52683,274440,510545,571446,570822,327694,1047184,108524,732078,686028,599578,1040195,385075,887022,290566,934408,863214,725988,338315,1009255,618882,1011222,78915,70230,121239,118919,11748,610779,520776,271189,638233,368854,747872,352460,454475,774051,555294,74079,282378,120692,106775,531221,201939,476673,298242,290330,405449,46908,947601,1038794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]