SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40898 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40898 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340290,273161,572044,571371,510770,99841,454820,297072,213301,871574,713949,286989,960102,429876,337337,894912,147519,145575,69288,394474,1032641,731501,560766,497912,24595,553774,492643,805662,381542,422758,413393,432856,142854,880046,628396,761991,526314,227087,697970,117774,537367,366583,510055,795036,49309,1001148,448491,426120,140834,617104,867305,169999,207017,201579,865278,72947,628458,160006,501176,283799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]