SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418889 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418889 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599898,796067,784332,847668,859343,848381,518106,421202,921239,518810,830347,605449,130121,142348,188928,188809,352969,418536,949986,573104,805004,114210,987120,96815,106451,504992,390386,1032732,426042,177311,521523,1008386,257986,679825,249436,621763,821189,941457,247144,809982,519904,737951,865903,356047,331547,731675,59582,779681,867529,100241,792848,338382,996595,911502,13905,668756,517520,712016,213906,368283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002158s ]